UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'plNGrFy8SQZk9MDo2R3hbeVfJ0ZbyG1wsZgkEpOEf3s='
WHERE
key_id = '7055a2916d3af7cb3c1d80d01b0a1f8af9cd50cf37c15d5d60d54b216e9dbee1'
AND (
token = 'plNGrFy8SQZk9MDo2R3hbeVfJ0ZbyG1wsZgkEpOEf3s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)