UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pAjGkGz7VUuUMfy6i5bPncCIHf8eK9IwVzsUwlhXkWM='
WHERE
key_id = '2cdb82bf2b1eb85e7979647cf5edb937e1a6f65d1df44c7956992a3421d2e9de'
AND (
token = 'pAjGkGz7VUuUMfy6i5bPncCIHf8eK9IwVzsUwlhXkWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)