UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/lHqX6ccdGt+VXCRr9DNJKRmt90MAMi4KVYgVBs0YG0='
WHERE
key_id = 'c123a12b365f1ecb2e2bef83b6926445a92e038d97079f1e3186402a3c2a2da3'
AND (
token = '/lHqX6ccdGt+VXCRr9DNJKRmt90MAMi4KVYgVBs0YG0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)