UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PURX/Vz4WUymfZwc8Mly9M/hsEO9RLdh2W4OErnpokE='
WHERE
key_id = '054022e2ae0510395efa7b774783b2fc4ac056cdd52875436332424d687bc4ad'
AND (
token = 'PURX/Vz4WUymfZwc8Mly9M/hsEO9RLdh2W4OErnpokE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)