UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B0kA5CBaM/nFrCmrAe15YlpZeaM4WXHzuGY3GJxSKNg='
WHERE
key_id = '58788799024a89d11b234f219581b931616e7a005a4dfe1857a9b0de0bbef6bc'
AND (
token = 'B0kA5CBaM/nFrCmrAe15YlpZeaM4WXHzuGY3GJxSKNg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)