UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GFAKTSV/U+NWMFfyfzN6lIZwT+sXXeeL6diey1MFiOU='
WHERE
key_id = '9b31a4329b6e325249b0e53b022cbe47646e12bb1b4a6caea8de4cace73217fc'
AND (
token = 'GFAKTSV/U+NWMFfyfzN6lIZwT+sXXeeL6diey1MFiOU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)