UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J9+4r9xnLVQBL5I6YR8AOAloDXYA7rtuGnCvmIvE5so='
WHERE
key_id = '8777a10a9189adca1f19ef0fc2007a2ef38440cf0bb4db4f00f9b3bd2b7173d0'
AND (
token = 'J9+4r9xnLVQBL5I6YR8AOAloDXYA7rtuGnCvmIvE5so='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)