UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+HNLLTgMDRWpoz8uUOZj7BiqrSUW4wreFxYwky6UMjA='
WHERE
key_id = '58046b0e02928e2650276a122ca752d9186b166d8ae67d86be8fa535dae2237e'
AND (
token = '+HNLLTgMDRWpoz8uUOZj7BiqrSUW4wreFxYwky6UMjA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)