UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HjQstUw6HwSJowv2GFC8lN5ssh5qH2E9Qyf7YxY6vI4='
WHERE
key_id = 'a9a042a4bd00b01cea2a1ea872ef988f25bcb0c7275a3a242faae53e2a2aa3c7'
AND (
token = 'HjQstUw6HwSJowv2GFC8lN5ssh5qH2E9Qyf7YxY6vI4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)