UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Yi4vzdis54x1gSYXak3EhAqqJ03lfpePNYB6Qug3Lvk='
WHERE
key_id = '8ce9f31f0a9c3d5b8869fd93c4b24e318c5f6cae44a845b5f0325eefe64156db'
AND (
token = 'Yi4vzdis54x1gSYXak3EhAqqJ03lfpePNYB6Qug3Lvk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)