UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8yC5zPaFfgVnb4jpb/UIfJKjm4hmCR/6pyItcosI4zg='
WHERE
key_id = '6c28353b4023ad93090212202d4e7aa44fe8207e394421a934d19f9a067d7324'
AND (
token = '8yC5zPaFfgVnb4jpb/UIfJKjm4hmCR/6pyItcosI4zg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)