UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NfwDISHXufbKAJWU4UwewRC/2uMV7LsfHgIRR8hrSqA='
WHERE
key_id = '76617882196a6ca43d4283d571e0c9a74fab26a1255b57bd1c8dd098c337c1fc'
AND (
token = 'NfwDISHXufbKAJWU4UwewRC/2uMV7LsfHgIRR8hrSqA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)