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