UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ctQHtA8bCs7ISH3qMttWq2+FaVQjlVFwexNhrQYHZ+4='
WHERE
key_id = 'bf1a34addfe88c5ab3e17a123635da6f67fe1686521cff79c1c6bfd8f7338b12'
AND (
token = 'ctQHtA8bCs7ISH3qMttWq2+FaVQjlVFwexNhrQYHZ+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)