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