UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BamSb9sFlY4DXx3/UMptnQle3mWn0UrVGEtk+8Fs+Q4='
WHERE
key_id = '02733624be4728ba8605f41d6efa19cd7afcaacb12f1d5d407a7490df476e147'
AND (
token = 'BamSb9sFlY4DXx3/UMptnQle3mWn0UrVGEtk+8Fs+Q4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)