UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2NxIafQ0zmO1yzSHwGhQhBeJ8BiuXHZiAX960VbZxPg='
WHERE
key_id = 'e39ca9cb824afa011ef265dc0cb32a23fa628e4826220ebd5ee879176bd3b5e7'
AND (
token = '2NxIafQ0zmO1yzSHwGhQhBeJ8BiuXHZiAX960VbZxPg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)