UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u+cApQYqclml7DHVbxqF5yjlhmD/twlrNk0imlE2dgc='
WHERE
key_id = 'd9704207e00c58cd9f7df38112cfc2db94da95faaa580c9fcab0a1250f405bae'
AND (
token = 'u+cApQYqclml7DHVbxqF5yjlhmD/twlrNk0imlE2dgc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)