UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gLCp2yF2WefZWyvAM421OJ3OzY2sStJ87tPjgOignk8='
WHERE
key_id = '1d0a95e85a09cfeb545a99abf96b3d93d2a9f8833a6690be875e043ac98f7b9a'
AND (
token = 'gLCp2yF2WefZWyvAM421OJ3OzY2sStJ87tPjgOignk8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)