UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ICVcfPpYwnE4C9zGsL5mBztYR4RA3bE/vV2uiR6E2tQ='
WHERE
key_id = '31dc63143e44ed02d2094aaebee6ea8ac4b4afd5111d668a7134da59afad1ed9'
AND (
token = 'ICVcfPpYwnE4C9zGsL5mBztYR4RA3bE/vV2uiR6E2tQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)