UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pEQJwdF/akPQrA1oDFrW9x08VT5fOMYPH6fdvAMvzQo='
WHERE
key_id = '20646cbff10a83ed5ce01348d1e70eb7d9af28f4f9716b19f0c9acf2862e14b4'
AND (
token = 'pEQJwdF/akPQrA1oDFrW9x08VT5fOMYPH6fdvAMvzQo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)