UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HEz30EUBvkqvHVHMXsDZA65S3WFWhcfNYWFhisj1nro='
WHERE
key_id = 'b3e5206e590bebac018601b75acaae8af32940507dc710f0c4a180a68e0e8ee6'
AND (
token = 'HEz30EUBvkqvHVHMXsDZA65S3WFWhcfNYWFhisj1nro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)