UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n8vxrwx3xnEsaOZV8Y0AMAv8wcGGJJ0bnpkBgHhhjng='
WHERE
key_id = '802758fc708e3b5e5b5218b21ba46984a3a61c03c28db25f81532eb304da94ec'
AND (
token = 'n8vxrwx3xnEsaOZV8Y0AMAv8wcGGJJ0bnpkBgHhhjng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)