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