UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VRO6gQ5TO8y8NPlkJl8cV4+dQAM/LEHGJpc9niEtKlM='
WHERE
key_id = 'a1dbd7eb5d187ca1935f1646368009350442ce933e6658723e09ec03f0b8251e'
AND (
token = 'VRO6gQ5TO8y8NPlkJl8cV4+dQAM/LEHGJpc9niEtKlM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)