UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KJir0J4Tdi5vvEnLPPN3h9N+CSQpO9YBs9AdUeR6E9k='
WHERE
key_id = '02d09a6b07b9a61bc0c7a09180a587a47378d0b3c45b0de2e071683998edd9fb'
AND (
token = 'KJir0J4Tdi5vvEnLPPN3h9N+CSQpO9YBs9AdUeR6E9k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)