UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x0awHvN9Mt3uX260YW8MWrsappeRzp+hABXDeI2t5Yw='
WHERE
key_id = '94058c9cf2e8c4804c787e33469e582aedc25069be068dd08f409147b5c38c65'
AND (
token = 'x0awHvN9Mt3uX260YW8MWrsappeRzp+hABXDeI2t5Yw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)