UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cYCY4pzvQHg9228OZ2hINn/E+tgEBtqjh8NsGWEtC9I='
WHERE
key_id = '0f0a15f8a0d24c2658ddd7b4a55561112b09fe5d29b0629622a8851fa517e962'
AND (
token = 'cYCY4pzvQHg9228OZ2hINn/E+tgEBtqjh8NsGWEtC9I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)