UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mhGw8cMIuUKqd0Gz9gN0PjkXFGXkw287VFgBlrUZFik='
WHERE
key_id = '460e8de9214bc0f907863adfb7f4ab00bf859f16696580514cfbe0e1fda33d2f'
AND (
token = 'mhGw8cMIuUKqd0Gz9gN0PjkXFGXkw287VFgBlrUZFik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)