UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xuIv23qZr16kU07G3xqxB46pOGTdkqvhkIasqWi1CB4='
WHERE
key_id = '248f3e18dc40830e634538e66efa724ef32c811b8e6a71ca2157825ac7cf3f17'
AND (
token = 'xuIv23qZr16kU07G3xqxB46pOGTdkqvhkIasqWi1CB4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)