UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YSudvpLgO3gbRasLTshN7Mzfnan9R6bFA/Lp2B0wui4='
WHERE
key_id = 'dd87b26df0178cc832ae78970fc4e66f1f5f8ca86e3ef393704c828dcd55e6d1'
AND (
token = 'YSudvpLgO3gbRasLTshN7Mzfnan9R6bFA/Lp2B0wui4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)