UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8zR/YUpXFo2w63lxA9OwYDtxmYZazaVKChYV0L78JZk='
WHERE
key_id = 'c47d3ec46bb6b8792e575d71d45e376d5f7055ed69a83a399c8fe7ed7636e18e'
AND (
token = '8zR/YUpXFo2w63lxA9OwYDtxmYZazaVKChYV0L78JZk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)