UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4kxiMeGPjXxztIalNRrYqG7Yzo9yqtdPD5DblphR9JU='
WHERE
key_id = '9597d2e73e743ab2bda9041f287b1557a56c404c06d9478d50aa739d4a9d00fc'
AND (
token = '4kxiMeGPjXxztIalNRrYqG7Yzo9yqtdPD5DblphR9JU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)