UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6FQUlCk8Luq4YvDYySTpcctwqVt9vayYNsS81SFRip8='
WHERE
key_id = 'd124a2932a42941f2ca77027e52fc324fe1ae7ec5590da2a2806515898768b97'
AND (
token = '6FQUlCk8Luq4YvDYySTpcctwqVt9vayYNsS81SFRip8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)